package com.cheer.dao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @author cheer
 */
@Mapper
@Repository
public interface MigrateDao {

    @Select("SELECT max(id) from oa_integral_detail")
    Long selectMaxId();

    @Select("SELECT * from oa_integral_detail where id > #{minId} and id <= #{maxId}")
    List<OldIntegralDetailEntity> selectListInRange(@Param("minId") Long minId, @Param("maxId") Long maxId);
}
